%% Import data from spreadsheet
% Script for importing data from the following spreadsheet:
%
%    Workbook: /Users/gregorjarosch/Dropbox/BU Job Search Analysis/scripts/bootstrap_expect/expect_b1.xls
%    Worksheet: Sheet1
%
% Auto-generated by MATLAB on 25-Aug-2020 16:56:19

%% Setup the Import Options
opts = spreadsheetImportOptions("NumVariables", 3);

% Specify sheet and range
opts.Sheet = "Sheet1";
opts.DataRange = "A2:C3";

% Specify column names and types
opts.VariableNames = ["Female", "MeanBaselineExpectation", "RevisioninMeanExpectMidBaseBase"];
opts.SelectedVariableNames = ["Female", "MeanBaselineExpectation", "RevisioninMeanExpectMidBaseBase"];
opts.VariableTypes = ["double", "double", "double"];

% Import the data
eval(['tbl = readtable("data/expect_b' int2str(bval) '.xls", opts, "UseExcel", false);'])

%% Convert to output type
Female = tbl.Female;
MeanBaselineExpectation = tbl.MeanBaselineExpectation;
RevisioninMeanExpectMidBaseBase = tbl.RevisioninMeanExpectMidBaseBase;

%% Clear temporary variables
clear opts tbl